package com.feng.vhr.mapper;

import com.feng.vhr.pojo.Salary;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author feng
 * @since 2022-05-09
 */
public interface SalaryMapper extends BaseMapper<Salary> {

    @Select("SELECT DISTINCT s.* FROM employee AS emp,empsalary AS emps,salary AS s WHERE emps.eid = #{id} AND emps.sid = s.id")
    public Salary getSalaryBySid(int id);

}
